{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["計算書","共用部入力方法（標準入力法）","共用部入力方法 (照明簡易計算)","太陽光発電設備の住戸按分計算シート","【参考】共用部の太陽光発電の扱いについて","Ver情報"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"計算書","index":0,"n_rows":521,"n_cols":198,"rows_kept":521,"cut":false,"hidden":false,"merged":[[514,1,514,5],[34,2,34,3],[36,2,36,3],[18,4,18,5],[61,1,61,5],[22,2,22,3],[71,1,71,5],[70,1,70,5],[73,1,73,5],[72,1,72,5],[64,1,64,3],[65,1,65,3],[37,2,47,2],[68,1,68,5],[69,1,69,5],[22,1,48,1],[3,15,3,18],[5,1,5,3],[520,1,520,5],[77,1,77,5],[513,1,513,5],[512,1,512,5],[511,5,511,6],[511,1,511,4],[515,1,515,5],[516,1,516,5],[517,1,517,5],[518,1,518,5],[519,1,519,5],[3,12,3,14],[14,1,21,1],[16,4,16,5],[3,1,3,2],[4,1,4,3],[6,1,6,3],[9,1,9,3],[51,1,58,1],[3,3,3,5],[6,4,6,5],[7,4,7,5],[7,1,7,3],[8,1,8,3],[8,4,8,5],[512,8,512,11],[513,8,513,11],[514,8,514,11],[511,8,511,11],[517,8,517,11],[515,8,516,11],[517,12,517,13],[515,12,515,13],[513,12,513,13],[511,12,511,13],[512,12,512,13],[514,12,514,13],[516,12,516,13],[11,6,21,6],[37,6,39,6],[15,2,15,3],[15,4,15,5],[16,2,18,2],[23,6,25,6],[11,1,11,3],[22,4,22,5],[62,1,62,3],[51,2,51,3],[56,2,56,3],[58,2,58,3],[53,2,53,3],[74,1,74,5],[67,1,67,3],[6,6,8,6],[11,4,11,5],[13,1,13,3],[21,2,21,3],[14,4,14,5],[14,2,14,3],[13,4,13,5],[12,4,12,5],[21,4,21,5],[12,1,12,3],[60,1,60,3],[63,1,63,3],[66,1,66,3],[23,2,33,2]]}
[null,"■住棟一次エネルギー消費量計算書"]
[null,"※申請書第六面及び設計内容説明書に代わる一覧表"]
[]
[null,"物件名",null,null,null,null,"地域区分",{"$f":"IF(H78=\"\",\"\",MID(H83,19,1)*1)","v":""},"住棟の\n延べ面積",null,"総住戸数",{"$f":"SUM(H7:GP7)","v":0},"住戸の存する建築物の用途\n（建築基準法上の用途区分）"]
[null,"住戸名称",null,null,"住棟全体","住戸合計","共用部の有無↓"]
[null,"申請の有無",null,null,"申請しない"]
[null,"同一計算結果住戸数"]
[null,"同一計算結果住戸名称"]
[null,"申請対象となる住戸が存する階"]
[null,"計算対象面積",null,null,{"$f":"IF($G$6=\"あり（計算する）\",IF(G10=\"\",\"\",SUM(F10,G10)),F10)","v":""},{"$f":"IF(H10=\"\",\"\",SUM(H11:GP11))","v":""},null,{"$f":"IF(H78=\"\",\"\",LEFT(RIGHT(H82,LEN(H82)-(FIND(\"*\",SUBSTITUTE(H82,\" \",\"*\",3)))),LEN(RIGHT(H82,LEN(H82)-(FIND(\"*\",SUBSTITUTE(H82,\" \",\"*\",3)))))-1)*1)","v":""},{"$f":"IF(I78=\"\",\"\",LEFT(RIGHT(I82,LEN(I82)-(FIND(\"*\",SUBSTITUTE(I82,\" \",\"*\",3)))),LEN(RIGHT(I82,LEN(I82)-(FIND(\"*\",SUBSTITUTE(I82,\" \",\"*\",3)))))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",LEFT(RIGHT(BU82,LEN(BU82)-(FIND(\"*\",SUBSTITUTE(BU82,\" \",\"*\",3)))),LEN(RIGHT(BU82,LEN(BU82)-(FIND(\"*\",SUBSTITUTE(BU82,\" \",\"*\",3)))))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",LEFT(RIGHT(EG82,LEN(EG82)-(FIND(\"*\",SUBSTITUTE(EG82,\" \",\"*\",3)))),LEN(RIGHT(EG82,LEN(EG82)-(FIND(\"*\",SUBSTITUTE(EG82,\" \",\"*\",3)))))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H10=\"\",\"\",H10*H7)","v":""},{"$f":"IF(I10=\"\",\"\",I10*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU10=\"\",\"\",BU10*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG10=\"\",\"\",EG10*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"改修前のＢＥＩ値",null,null,"記載なし",null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$F$489)","v":""},"","","","","","","","","",{"$f":"IF(COUNTBLANK(R5)=1,\"\",$F$489)","v":""},"","","",{"$f":"IF(COUNTBLANK(V5)=1,\"\",$F$489)","v":""},"","","","","","",{"$f":"IF(COUNTBLANK(AC5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AX5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CD5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(DJ5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EP5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FV5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,"ＺＥＨマーク・ゼロエネ相当等表示",null,null,"『ZEH-M』",null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$D$494)","v":""},"","","","","","","","","",{"$f":"IF(COUNTBLANK(R5)=1,\"\",$D$494)","v":""},"","","",{"$f":"IF(COUNTBLANK(V5)=1,\"\",$D$494)","v":""},"","","","","","",{"$f":"IF(COUNTBLANK(AC5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AV5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CB5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(DH5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EN5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FT5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"参考情報（二次エネ以外）の掲載の選択",null,null,"記載なし",null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$G$489)","v":""},"","","","","","","","","",{"$f":"IF(COUNTBLANK(R5)=1,\"\",$G$489)","v":""},"","","",{"$f":"IF(COUNTBLANK(V5)=1,\"\",$G$489)","v":""},"","","","","","",{"$f":"IF(COUNTBLANK(AC5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AV5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CB5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(DH5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EN5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FT5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"外皮性能","評価手法（住戸評価or住棟評価）",null,"住戸評価",null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$C$489)","v":""},"","","","","","","","","",{"$f":"IF(COUNTBLANK(R5)=1,\"\",$C$489)","v":""},"","","",{"$f":"IF(COUNTBLANK(V5)=1,\"\",$C$489)","v":""},"","","","","","",{"$f":"IF(COUNTBLANK(AC5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AV5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CB5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(DH5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EN5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FT5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"表示希望の選択",null,"UA値",null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$P$489)","v":""},"","","","","","","","","",{"$f":"IF(COUNTBLANK(R5)=1,\"\",$P$489)","v":""},"","","",{"$f":"IF(COUNTBLANK(V5)=1,\"\",$P$489)","v":""},"","","","","","",{"$f":"IF(COUNTBLANK(AC5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AV5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CB5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(DH5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EN5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FT5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"設計値","ＵＡ",{"$f":"IF(ISERROR(SUM(H18:GP18)/L4),\"\",ROUNDUP(SUM(H18:GP18)/L4,2))","v":""},null,null,{"$f":"IF(H78=\"\",\"\",LEFT(RIGHT(INDEX(H79:H480,MATCH(\"外皮平均熱貫流率*\",H79:H480,0),1),LEN(INDEX(H79:H480,MATCH(\"外皮平均熱貫流率*\",H79:H480,0),1))-8),LEN(RIGHT(INDEX(H79:H480,MATCH(\"外皮平均熱貫流率*\",H79:H480,0),1),LEN(INDEX(H79:H480,MATCH(\"外皮平均熱貫流率*\",H79:H480,0),1))-8))-5)*1)","v":""},{"$f":"IF(I78=\"\",\"\",LEFT(RIGHT(INDEX(I79:I480,MATCH(\"外皮平均熱貫流率*\",I79:I480,0),1),LEN(INDEX(I79:I480,MATCH(\"外皮平均熱貫流率*\",I79:I480,0),1))-8),LEN(RIGHT(INDEX(I79:I480,MATCH(\"外皮平均熱貫流率*\",I79:I480,0),1),LEN(INDEX(I79:I480,MATCH(\"外皮平均熱貫流率*\",I79:I480,0),1))-8))-5)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",LEFT(RIGHT(INDEX(BU79:BU480,MATCH(\"外皮平均熱貫流率*\",BU79:BU480,0),1),LEN(INDEX(BU79:BU480,MATCH(\"外皮平均熱貫流率*\",BU79:BU480,0),1))-8),LEN(RIGHT(INDEX(BU79:BU480,MATCH(\"外皮平均熱貫流率*\",BU79:BU480,0),1),LEN(INDEX(BU79:BU480,MATCH(\"外皮平均熱貫流率*\",BU79:BU480,0),1))-8))-5)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",LEFT(RIGHT(INDEX(EG79:EG480,MATCH(\"外皮平均熱貫流率*\",EG79:EG480,0),1),LEN(INDEX(EG79:EG480,MATCH(\"外皮平均熱貫流率*\",EG79:EG480,0),1))-8),LEN(RIGHT(INDEX(EG79:EG480,MATCH(\"外皮平均熱貫流率*\",EG79:EG480,0),1),LEN(INDEX(EG79:EG480,MATCH(\"外皮平均熱貫流率*\",EG79:EG480,0),1))-8))-5)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H17=\"\",\"\",H17*H7)","v":""},{"$f":"IF(I17=\"\",\"\",I17*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU17=\"\",\"\",BU17*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG17=\"\",\"\",EG17*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"ηＡＣ",{"$f":"IF(ISERROR(SUM(H20:GP20)/L4),\"\",ROUNDUP(SUM(H20:GP20)/L4,1))","v":""},null,null,{"$f":"IF(H78=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(H79:H480,MATCH(\"平均日射熱取得率暖房期*\",H79:H480,0),1),3),\":\",\"\")*1)","v":""},{"$f":"IF(I78=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(I79:I480,MATCH(\"平均日射熱取得率暖房期*\",I79:I480,0),1),3),\":\",\"\")*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(BU79:BU480,MATCH(\"平均日射熱取得率暖房期*\",BU79:BU480,0),1),3),\":\",\"\")*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(EG79:EG480,MATCH(\"平均日射熱取得率暖房期*\",EG79:EG480,0),1),3),\":\",\"\")*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H19=\"\",\"\",H19*H7)","v":""},{"$f":"IF(I19=\"\",\"\",I19*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU19=\"\",\"\",BU19*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG19=\"\",\"\",EG19*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"基準値（左：住棟　右：住戸）","ＵＡ・ηＡＣ",{"$f":"IF(H4=\"\",\"\",IF(E15=\"\",\"\",VLOOKUP(H4,J489:Q496,8)))","v":""},{"$f":"IF(H4=\"\",\"\",IF(E15=\"\",\"\",VLOOKUP(H4,J489:Q496,2)))","v":""},null,{"$f":"IF(OR(H5=\"\",H17=\"\",H19=\"\"),\"\",IF(AND(H17<=VLOOKUP($H$4,$J$489:$M$496,4),H19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AN5=\"\",AN17=\"\",AN19=\"\"),\"\",IF(AND(AN17<=VLOOKUP($H$4,$J$489:$M$496,4),AN19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BT5=\"\",BT17=\"\",BT19=\"\"),\"\",IF(AND(BT17<=VLOOKUP($H$4,$J$489:$M$496,4),BT19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(CZ5=\"\",CZ17=\"\",CZ19=\"\"),\"\",IF(AND(CZ17<=VLOOKUP($H$4,$J$489:$M$496,4),CZ19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EF5=\"\",EF17=\"\",EF19=\"\"),\"\",IF(AND(EF17<=VLOOKUP($H$4,$J$489:$M$496,4),EF19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(FL5=\"\",FL17=\"\",FL19=\"\"),\"\",IF(AND(FL17<=VLOOKUP($H$4,$J$489:$M$496,4),FL19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"住戸の強化外皮基準（ＵＡ）",null,{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,J489:L496,3))","v":""},null,null,{"$f":"IF(OR(H5=\"\",H17=\"\"),\"\",IF(H17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AN5=\"\",AN17=\"\"),\"\",IF(AN17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BT5=\"\",BT17=\"\"),\"\",IF(BT17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(CZ5=\"\",CZ17=\"\"),\"\",IF(CZ17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EF5=\"\",EF17=\"\"),\"\",IF(EF17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(FL5=\"\",FL17=\"\"),\"\",IF(FL17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["一次エネルギー消費量","一次エネルギー消費量","評価手法",null,"性能基準",null,null,{"$f":"IF(COUNTBLANK(H13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(V13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AW13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CC13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(DI13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EO13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FU13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,"         設計値\n\n共用部\n標準入力：MJ/延床㎡年\n\n住戸:MJ","暖房",null,{"$f":"SUM(H25:GP25)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H85,LEN(H85)-4),FIND(\" \",RIGHT(H85,LEN(H85)-4)))*1),\"\",LEFT(RIGHT(H85,LEN(H85)-4),FIND(\" \",RIGHT(H85,LEN(H85)-4)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I85,LEN(I85)-4),FIND(\" \",RIGHT(I85,LEN(I85)-4)))*1),\"\",LEFT(RIGHT(I85,LEN(I85)-4),FIND(\" \",RIGHT(I85,LEN(I85)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU85,LEN(BU85)-4),FIND(\" \",RIGHT(BU85,LEN(BU85)-4)))*1),\"\",LEFT(RIGHT(BU85,LEN(BU85)-4),FIND(\" \",RIGHT(BU85,LEN(BU85)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG85,LEN(EG85)-4),FIND(\" \",RIGHT(EG85,LEN(EG85)-4)))*1),\"\",LEFT(RIGHT(EG85,LEN(EG85)-4),FIND(\" \",RIGHT(EG85,LEN(EG85)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H24=\"\",\"\",H24*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN24=\"\",\"\",AN24*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT24=\"\",\"\",BT24*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ24=\"\",\"\",CZ24*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF24=\"\",\"\",EF24*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL24=\"\",\"\",FL24*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"冷房",null,{"$f":"SUM(H27:GP27)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H86,LEN(H86)-4),FIND(\" \",RIGHT(H86,LEN(H86)-4)))*1),\"\",LEFT(RIGHT(H86,LEN(H86)-4),FIND(\" \",RIGHT(H86,LEN(H86)-4)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I86,LEN(I86)-4),FIND(\" \",RIGHT(I86,LEN(I86)-4)))*1),\"\",LEFT(RIGHT(I86,LEN(I86)-4),FIND(\" \",RIGHT(I86,LEN(I86)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU86,LEN(BU86)-4),FIND(\" \",RIGHT(BU86,LEN(BU86)-4)))*1),\"\",LEFT(RIGHT(BU86,LEN(BU86)-4),FIND(\" \",RIGHT(BU86,LEN(BU86)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG86,LEN(EG86)-4),FIND(\" \",RIGHT(EG86,LEN(EG86)-4)))*1),\"\",LEFT(RIGHT(EG86,LEN(EG86)-4),FIND(\" \",RIGHT(EG86,LEN(EG86)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H26=\"\",\"\",H26*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN26=\"\",\"\",AN26*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT26=\"\",\"\",BT26*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ26=\"\",\"\",CZ26*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF26=\"\",\"\",EF26*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL26=\"\",\"\",FL26*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"換気",null,{"$f":"SUM(H29:GP29)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H87,LEN(H87)-4),FIND(\" \",RIGHT(H87,LEN(H87)-4)))*1),\"\",LEFT(RIGHT(H87,LEN(H87)-4),FIND(\" \",RIGHT(H87,LEN(H87)-4)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I87,LEN(I87)-4),FIND(\" \",RIGHT(I87,LEN(I87)-4)))*1),\"\",LEFT(RIGHT(I87,LEN(I87)-4),FIND(\" \",RIGHT(I87,LEN(I87)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU87,LEN(BU87)-4),FIND(\" \",RIGHT(BU87,LEN(BU87)-4)))*1),\"\",LEFT(RIGHT(BU87,LEN(BU87)-4),FIND(\" \",RIGHT(BU87,LEN(BU87)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG87,LEN(EG87)-4),FIND(\" \",RIGHT(EG87,LEN(EG87)-4)))*1),\"\",LEFT(RIGHT(EG87,LEN(EG87)-4),FIND(\" \",RIGHT(EG87,LEN(EG87)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",H28*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN28=\"\",\"\",AN28*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT28=\"\",\"\",BT28*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ28=\"\",\"\",CZ28*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF28=\"\",\"\",EF28*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL28=\"\",\"\",FL28*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"照明",null,{"$f":"SUM(H31:GP31)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H89,LEN(H89)-4),FIND(\" \",RIGHT(H89,LEN(H89)-4)))*1),\"\",LEFT(RIGHT(H89,LEN(H89)-4),FIND(\" \",RIGHT(H89,LEN(H89)-4)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I89,LEN(I89)-4),FIND(\" \",RIGHT(I89,LEN(I89)-4)))*1),\"\",LEFT(RIGHT(I89,LEN(I89)-4),FIND(\" \",RIGHT(I89,LEN(I89)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU89,LEN(BU89)-4),FIND(\" \",RIGHT(BU89,LEN(BU89)-4)))*1),\"\",LEFT(RIGHT(BU89,LEN(BU89)-4),FIND(\" \",RIGHT(BU89,LEN(BU89)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG89,LEN(EG89)-4),FIND(\" \",RIGHT(EG89,LEN(EG89)-4)))*1),\"\",LEFT(RIGHT(EG89,LEN(EG89)-4),FIND(\" \",RIGHT(EG89,LEN(EG89)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H30=\"\",\"\",H30*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN30=\"\",\"\",AN30*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT30=\"\",\"\",BT30*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ30=\"\",\"\",CZ30*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF30=\"\",\"\",EF30*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL30=\"\",\"\",FL30*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"給湯",null,{"$f":"SUM(H33:GP33)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H88,LEN(H88)-4),FIND(\" \",RIGHT(H88,LEN(H88)-4)))*1),\"\",LEFT(RIGHT(H88,LEN(H88)-4),FIND(\" \",RIGHT(H88,LEN(H88)-4)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I88,LEN(I88)-4),FIND(\" \",RIGHT(I88,LEN(I88)-4)))*1),\"\",LEFT(RIGHT(I88,LEN(I88)-4),FIND(\" \",RIGHT(I88,LEN(I88)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU88,LEN(BU88)-4),FIND(\" \",RIGHT(BU88,LEN(BU88)-4)))*1),\"\",LEFT(RIGHT(BU88,LEN(BU88)-4),FIND(\" \",RIGHT(BU88,LEN(BU88)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG88,LEN(EG88)-4),FIND(\" \",RIGHT(EG88,LEN(EG88)-4)))*1),\"\",LEFT(RIGHT(EG88,LEN(EG88)-4),FIND(\" \",RIGHT(EG88,LEN(EG88)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H32=\"\",\"\",H32*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN32=\"\",\"\",AN32*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT32=\"\",\"\",BT32*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ32=\"\",\"\",CZ32*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF32=\"\",\"\",EF32*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL32=\"\",\"\",FL32*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"昇降機"]
[null,null,"発電設備の発電量のうち自家消費分",null,null,{"$f":"IF(H78=\"\",\"\",SUM(H36:GP36))","v":""},{"$f":"IF(OR(G23=\"\",G23=\"照明簡易計算\",G6=\"なし\",G6=\"あり（計算除外）\"),\"\",IF(G23=\"標準入力法\",IF(OR(M514=\"屋内\",M514=\"屋外\"),IFERROR(-M516,0),IFERROR(-M517,0)),IF(M512=\"無し\",0,\"\")))","v":""},{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H91,LEN(H91)-20),FIND(\" \",RIGHT(H91,LEN(H91)-20)))*1),0,LEFT(RIGHT(H91,LEN(H91)-20),FIND(\" \",RIGHT(H91,LEN(H91)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(AN91,LEN(AN91)-20),FIND(\" \",RIGHT(AN91,LEN(AN91)-20)))*1),0,LEFT(RIGHT(AN91,LEN(AN91)-20),FIND(\" \",RIGHT(AN91,LEN(AN91)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BT91,LEN(BT91)-20),FIND(\" \",RIGHT(BT91,LEN(BT91)-20)))*1),0,LEFT(RIGHT(BT91,LEN(BT91)-20),FIND(\" \",RIGHT(BT91,LEN(BT91)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(CZ91,LEN(CZ91)-20),FIND(\" \",RIGHT(CZ91,LEN(CZ91)-20)))*1),0,LEFT(RIGHT(CZ91,LEN(CZ91)-20),FIND(\" \",RIGHT(CZ91,LEN(CZ91)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EF91,LEN(EF91)-20),FIND(\" \",RIGHT(EF91,LEN(EF91)-20)))*1),0,LEFT(RIGHT(EF91,LEN(EF91)-20),FIND(\" \",RIGHT(EF91,LEN(EF91)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(FL91,LEN(FL91)-20),FIND(\" \",RIGHT(FL91,LEN(FL91)-20)))*1),0,LEFT(RIGHT(FL91,LEN(FL91)-20),FIND(\" \",RIGHT(FL91,LEN(FL91)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IF(G35=\"\",\"\",ROUNDUP(G35/1000,1))","v":""},{"$f":"IF(H35=\"\",\"\",H35*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN35=\"\",\"\",AN35*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT35=\"\",\"\",BT35*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ35=\"\",\"\",CZ35*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF35=\"\",\"\",EF35*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL35=\"\",\"\",FL35*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"コジェネ設備の売電量に係る控除量",null,null,{"$f":"IF(H80=\"\",\"\",SUM(H51:GP51))","v":""},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H92,LEN(H92)-26),FIND(\" \",RIGHT(H92,LEN(H92)-26)))*1),0,LEFT(RIGHT(H92,LEN(H92)-26),FIND(\" \",RIGHT(H92,LEN(H92)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(AN92,LEN(AN92)-26),FIND(\" \",RIGHT(AN92,LEN(AN92)-26)))*1),0,LEFT(RIGHT(AN92,LEN(AN92)-26),FIND(\" \",RIGHT(AN92,LEN(AN92)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BT92,LEN(BT92)-26),FIND(\" \",RIGHT(BT92,LEN(BT92)-26)))*1),0,LEFT(RIGHT(BT92,LEN(BT92)-26),FIND(\" \",RIGHT(BT92,LEN(BT92)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(CZ92,LEN(CZ92)-26),FIND(\" \",RIGHT(CZ92,LEN(CZ92)-26)))*1),0,LEFT(RIGHT(CZ92,LEN(CZ92)-26),FIND(\" \",RIGHT(CZ92,LEN(CZ92)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EF92,LEN(EF92)-26),FIND(\" \",RIGHT(EF92,LEN(EF92)-26)))*1),0,LEFT(RIGHT(EF92,LEN(EF92)-26),FIND(\" \",RIGHT(EF92,LEN(EF92)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(FL92,LEN(FL92)-26),FIND(\" \",RIGHT(FL92,LEN(FL92)-26)))*1),0,LEFT(RIGHT(FL92,LEN(FL92)-26),FIND(\" \",RIGHT(FL92,LEN(FL92)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"         基準値\n\n共用部 \n標準入力:MJ/延床㎡年\n\n住戸:MJ","暖房",null,{"$f":"SUM(H39:GP39)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H85,FIND(\" \",H85),10)*1),\"\",MID(H85,FIND(\" \",H85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN78=\"\",\"\",IF(ISERROR(MID(AN85,FIND(\" \",AN85),10)*1),\"\",MID(AN85,FIND(\" \",AN85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IF(ISERROR(MID(BT85,FIND(\" \",BT85),10)*1),\"\",MID(BT85,FIND(\" \",BT85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ78=\"\",\"\",IF(ISERROR(MID(CZ85,FIND(\" \",CZ85),10)*1),\"\",MID(CZ85,FIND(\" \",CZ85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IF(ISERROR(MID(EF85,FIND(\" \",EF85),10)*1),\"\",MID(EF85,FIND(\" \",EF85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL78=\"\",\"\",IF(ISERROR(MID(FL85,FIND(\" \",FL85),10)*1),\"\",MID(FL85,FIND(\" \",FL85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H38=\"\",\"\",H38*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN38=\"\",\"\",AN38*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT38=\"\",\"\",BT38*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ38=\"\",\"\",CZ38*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF38=\"\",\"\",EF38*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL38=\"\",\"\",FL38*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"冷房",null,{"$f":"SUM(H41:GP41)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H86,FIND(\" \",H86),10)*1),\"\",MID(H86,FIND(\" \",H86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN78=\"\",\"\",IF(ISERROR(MID(AN86,FIND(\" \",AN86),10)*1),\"\",MID(AN86,FIND(\" \",AN86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IF(ISERROR(MID(BT86,FIND(\" \",BT86),10)*1),\"\",MID(BT86,FIND(\" \",BT86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ78=\"\",\"\",IF(ISERROR(MID(CZ86,FIND(\" \",CZ86),10)*1),\"\",MID(CZ86,FIND(\" \",CZ86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IF(ISERROR(MID(EF86,FIND(\" \",EF86),10)*1),\"\",MID(EF86,FIND(\" \",EF86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL78=\"\",\"\",IF(ISERROR(MID(FL86,FIND(\" \",FL86),10)*1),\"\",MID(FL86,FIND(\" \",FL86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H40=\"\",\"\",H40*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN40=\"\",\"\",AN40*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT40=\"\",\"\",BT40*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ40=\"\",\"\",CZ40*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF40=\"\",\"\",EF40*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL40=\"\",\"\",FL40*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"換気",null,{"$f":"SUM(H43:GP43)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H87,FIND(\" \",H87),10)*1),\"\",MID(H87,FIND(\" \",H87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN78=\"\",\"\",IF(ISERROR(MID(AN87,FIND(\" \",AN87),10)*1),\"\",MID(AN87,FIND(\" \",AN87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IF(ISERROR(MID(BT87,FIND(\" \",BT87),10)*1),\"\",MID(BT87,FIND(\" \",BT87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ78=\"\",\"\",IF(ISERROR(MID(CZ87,FIND(\" \",CZ87),10)*1),\"\",MID(CZ87,FIND(\" \",CZ87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IF(ISERROR(MID(EF87,FIND(\" \",EF87),10)*1),\"\",MID(EF87,FIND(\" \",EF87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL78=\"\",\"\",IF(ISERROR(MID(FL87,FIND(\" \",FL87),10)*1),\"\",MID(FL87,FIND(\" \",FL87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H42=\"\",\"\",H42*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN42=\"\",\"\",AN42*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT42=\"\",\"\",BT42*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ42=\"\",\"\",CZ42*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF42=\"\",\"\",EF42*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL42=\"\",\"\",FL42*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"照明",null,{"$f":"SUM(H45:GP45)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H89,FIND(\" \",H89),10)*1),\"\",MID(H89,FIND(\" \",H89),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN78=\"\",\"\",IF(ISERROR(MID(AN89,FIND(\" \",AN89),10)*1),\"\",MID(AN89,FIND(\" \",AN89),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IF(ISERROR(MID(BT89,FIND(\" \",BT89),10)*1),\"\",MID(BT89,FIND(\" \",BT89),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ78=\"\",\"\",IF(ISERROR(MID(CZ89,FIND(\" \",CZ89),10)*1),\"\",MID(CZ89,FIND(\" \",CZ89),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IF(ISERROR(MID(EF89,FIND(\" \",EF89),10)*1),\"\",MID(EF89,FIND(\" \",EF89),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL78=\"\",\"\",IF(ISERROR(MID(FL89,FIND(\" \",FL89),10)*1),\"\",MID(FL89,FIND(\" \",FL89),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H44=\"\",\"\",H44*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN44=\"\",\"\",AN44*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT44=\"\",\"\",BT44*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ44=\"\",\"\",CZ44*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF44=\"\",\"\",EF44*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL44=\"\",\"\",FL44*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"給湯",null,{"$f":"SUM(H47:GP47)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H88,FIND(\" \",H88),10)*1),\"\",MID(H88,FIND(\" \",H88),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN78=\"\",\"\",IF(ISERROR(MID(AN88,FIND(\" \",AN88),10)*1),\"\",MID(AN88,FIND(\" \",AN88),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IF(ISERROR(MID(BT88,FIND(\" \",BT88),10)*1),\"\",MID(BT88,FIND(\" \",BT88),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ78=\"\",\"\",IF(ISERROR(MID(CZ88,FIND(\" \",CZ88),10)*1),\"\",MID(CZ88,FIND(\" \",CZ88),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IF(ISERROR(MID(EF88,FIND(\" \",EF88),10)*1),\"\",MID(EF88,FIND(\" \",EF88),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL78=\"\",\"\",IF(ISERROR(MID(FL88,FIND(\" \",FL88),10)*1),\"\",MID(FL88,FIND(\" \",FL88),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H46=\"\",\"\",H46*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN46=\"\",\"\",AN46*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT46=\"\",\"\",BT46*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ46=\"\",\"\",CZ46*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF46=\"\",\"\",EF46*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL46=\"\",\"\",FL46*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"昇降機"]
[null,null,"基準・設計","その他",null,{"$f":"SUM(H50:GP50)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H90,FIND(\" \",H90),10)*1),\"\",MID(H90,FIND(\" \",H90),10)*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(MID(I90,FIND(\" \",I90),10)*1),\"\",MID(I90,FIND(\" \",I90),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(MID(BU90,FIND(\" \",BU90),10)*1),\"\",MID(BU90,FIND(\" \",BU90),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(MID(EG90,FIND(\" \",EG90),10)*1),\"\",MID(EG90,FIND(\" \",EG90),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H49=\"\",\"\",H49*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN49=\"\",\"\",AN49*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT49=\"\",\"\",BT49*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ49=\"\",\"\",CZ49*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF49=\"\",\"\",EF49*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL49=\"\",\"\",FL49*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H37=\"\",\"\",H37*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN37=\"\",\"\",AN37*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT37=\"\",\"\",BT37*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ37=\"\",\"\",CZ37*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF37=\"\",\"\",EF37*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL37=\"\",\"\",FL37*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"参考値","発電量（ｺｰｼﾞｪﾈﾚｰｼｮﾝ）",null,null,{"$f":"IF(H78=\"\",\"\",SUM(H53:GP53))","v":""},null,{"$f":"IF(H78=\"\",\"\",IFERROR(LEFT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IFERROR(LEFT(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IFERROR(LEFT(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H52=\"\",\"\",H52*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN52=\"\",\"\",AN52*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT52=\"\",\"\",BT52*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ52=\"\",\"\",CZ52*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF52=\"\",\"\",EF52*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL52=\"\",\"\",FL52*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"発電量（太陽光発電）",null,null,{"$f":"IF(H78=\"\",\"\",SUM(H55:GP55))","v":""},{"$f":"IF(OR(G23=\"\",$G$23=\"照明簡易計算\",$G$6=\"なし\",G6=\"あり（計算除外）\"),\"\",IF(OR(M512=\"無し\",M513=\"住戸・共用部で共有\"),0,-M518))","v":""},{"$f":"IF(H78=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))),FIND(\" \",RIGHT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),LEN(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))),FIND(\" \",RIGHT(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),LEN(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),LEN(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))),FIND(\" \",RIGHT(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),LEN(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H54=\"\",\"\",H54*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN54=\"\",\"\",AN54*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT54=\"\",\"\",BT54*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ54=\"\",\"\",CZ54*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF54=\"\",\"\",EF54*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL54=\"\",\"\",FL54*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"LEFT(RIGHT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))+1)))-1)","v":{"$error":"#N/A"}},{"$f":"LEFT(RIGHT(INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),LEN(INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1))-FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),LEN(INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1))-FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1))+1)))-1)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LEFT(RIGHT(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),LEN(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),LEN(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))+1)))-1)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LEFT(RIGHT(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),LEN(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),LEN(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))+1)))-1)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"売電量（ｺｰｼﾞｪﾈﾚｰｼｮﾝ）",null,null,{"$f":"IF(H81=\"\",\"\",SUM(H58:GP58))","v":""},null,{"$f":"IF(H78=\"\",\"\",IFERROR(H56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN78=\"\",\"\",IFERROR(AN56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IFERROR(BT56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ78=\"\",\"\",IFERROR(CZ56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IFERROR(EF56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL78=\"\",\"\",IFERROR(FL56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H57=\"\",\"\",H57*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN57=\"\",\"\",AN57*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT57=\"\",\"\",BT57*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ57=\"\",\"\",CZ57*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF57=\"\",\"\",EF57*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL57=\"\",\"\",FL57*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"売電量（太陽光発電）",null,null,{"$f":"IF(H78=\"\",\"\",SUM(H60:GP60))","v":""},null,{"$f":"IF(H78=\"\",\"\",IFERROR(RIGHT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))+1)+1))*1,0))","v":""},{"$f":"IF(I78=\"\",\"\",IFERROR(RIGHT(INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),LEN(INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1))-FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1))+1)+1))*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IFERROR(RIGHT(INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1),LEN(INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1))-FIND(\" \",INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1),FIND(\" \",INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1),FIND(\" \",INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1))+1)+1))*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IFERROR(RIGHT(INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1),LEN(INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1))-FIND(\" \",INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1),FIND(\" \",INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1),FIND(\" \",INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1))+1)+1))*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H59=\"\",\"\",H59*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN59=\"\",\"\",AN59*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT59=\"\",\"\",BT59*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ59=\"\",\"\",CZ59*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF59=\"\",\"\",EF59*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL59=\"\",\"\",FL59*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"設計一次エネルギー消費量（その他除く）",null,null,{"$f":"IF($G$6=\"あり（計算する）\",IF(OR(G61=\"\",G23=\"\"),\"\",IF(ISERROR(F61+G62),\"\",F61+G62)),F61)","v":0},{"$f":"SUM(H63:GP63)","v":0},null,{"$f":"IF(H78=\"\",\"\",LEFT(RIGHT(H94,LEN(H94)-35),FIND(\" \",RIGHT(H94,LEN(H94)-35))-1)*1)","v":""},{"$f":"IF(I78=\"\",\"\",LEFT(RIGHT(I94,LEN(I94)-35),FIND(\" \",RIGHT(I94,LEN(I94)-35))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",LEFT(RIGHT(BU94,LEN(BU94)-35),FIND(\" \",RIGHT(BU94,LEN(BU94)-35))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",LEFT(RIGHT(EG94,LEN(EG94)-35),FIND(\" \",RIGHT(EG94,LEN(EG94)-35))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"共用部 設計一次エネ消費量（その他除く）自己消費量考慮後の合計",null,null,null,null,{"$f":"IF(OR(G6=\"あり（計算除外）\",G6=\"なし\",G6=\"\",G23=\"\"),0,IF($G$23=\"照明簡易計算\",ROUNDUP(G61/1000,1),IF(M512=\"無し\",G61,IF(M513=\"共有無し\",IF(OR(M515=\"\",M518=\"\"),\"\",G61+M518+G36),IF(M515=\"\",\"\",M515+G36)))))","v":0}]
[null,"参考　設計一次エネ（設備の合計）",null,null,{"$f":"IF(ISERROR(SUM(F63,G63)),\"\",SUM(F63,G63))","v":0},{"$f":"ROUNDUP(SUM(F24,F26,F28,F30,F32,F35,F37)/1000,1)","v":0},{"$f":"IF(OR($G$6=\"あり（計算除外）\",G6=\"なし\"),\"\",IF($G$23=\"標準入力法\",AC505,IF($G$23=\"照明簡易計算\",ROUNDUP(G61/1000,1),0)))","v":0},{"$f":"IF(H61=\"\",\"\",H61*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN61=\"\",\"\",AN61*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT61=\"\",\"\",BT61*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ61=\"\",\"\",CZ61*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF61=\"\",\"\",EF61*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL61=\"\",\"\",FL61*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"基準一次エネルギー消費量（その他除く）",null,null,{"$f":"IF($G$6=\"あり（計算する）\",IF(G64=\"\",\"\",IF(ISERROR(F64+G65),\"\",F64+G65)),F64)","v":0},{"$f":"SUM(H65:GP65)","v":0},null,{"$f":"IF(H78=\"\",\"\",MID(RIGHT(H94,LEN(H94)-35),FIND(\" \",RIGHT(H94,LEN(H94)-35)),10)*1)","v":""},{"$f":"IF(I78=\"\",\"\",MID(RIGHT(I94,LEN(I94)-35),FIND(\" \",RIGHT(I94,LEN(I94)-35)),10)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",MID(RIGHT(BU94,LEN(BU94)-35),FIND(\" \",RIGHT(BU94,LEN(BU94)-35)),10)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",MID(RIGHT(EG94,LEN(EG94)-35),FIND(\" \",RIGHT(EG94,LEN(EG94)-35)),10)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"BEI算定用　基準一次エネ",null,null,null,null,{"$f":"IF($G$6=\"あり（計算する）\",IF($G$23=\"標準入力法\",G64,IF($G$23=\"照明簡易計算\",ROUNDUP(G64/1000,1))),0)","v":0},{"$f":"IF(H64=\"\",\"\",H64*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN64=\"\",\"\",AN64*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT64=\"\",\"\",BT64*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ64=\"\",\"\",CZ64*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF64=\"\",\"\",EF64*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL64=\"\",\"\",FL64*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"参考　基準一次エネ（設備の合計）",null,null,{"$f":"IF(ISERROR(SUM(F66,G66)),\"\",SUM(F66,G66))","v":0},{"$f":"ROUNDUP(SUM(F38,F40,F42,F44,F46)/1000,1)","v":0},{"$f":"IF($G$6=\"あり（計算する）\",IF($G$23=\"標準入力法\",AC503,IF($G$23=\"照明簡易計算\",ROUNDUP(G64/1000,1))),0)","v":0}]
[null,"ＢＥＩ",null,null,{"$f":"IF(OR(E10=\"\",G6=\"\"),\"\",IF(ISERROR(E61/E64),\"\",ROUNDUP(E61/E64,2)))","v":""},null,null,{"$f":"IF(H78=\"\",\"\",RIGHT(H95,4)*1)","v":""},{"$f":"IF(I78=\"\",\"\",RIGHT(I95,4)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",RIGHT(BU95,4)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",RIGHT(EG95,4)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"☆数",null,null,{"$f":"IF(E67=\"\",\"\",IF(E67<=0.8,\"☆☆☆☆☆\",IF(E67<=0.85,\"☆☆☆☆\",IF(E67<=0.9,\"☆☆☆\",IF(E67<=1,\"☆☆\",IF(E67<=1.1,\"☆\",\"-\"))))))","v":""},null,null,{"$f":"IF(H67=\"\",\"\",IF(H67<=0.8,\"☆☆☆☆☆\",IF(H67<=0.85,\"☆☆☆☆\",IF(H67<=0.9,\"☆☆☆\",IF(H67<=1,\"☆☆\",IF(H67<=1.1,\"☆\",\"-\"))))))","v":""},{"$f":"IF(I67=\"\",\"\",IF(I67<=0.8,\"☆☆☆☆☆\",IF(I67<=0.85,\"☆☆☆☆\",IF(I67<=0.9,\"☆☆☆\",IF(I67<=1,\"☆☆\",IF(I67<=1.1,\"☆\",\"-\"))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU67=\"\",\"\",IF(BU67<=0.8,\"☆☆☆☆☆\",IF(BU67<=0.85,\"☆☆☆☆\",IF(BU67<=0.9,\"☆☆☆\",IF(BU67<=1,\"☆☆\",IF(BU67<=1.1,\"☆\",\"-\"))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG67=\"\",\"\",IF(EG67<=0.8,\"☆☆☆☆☆\",IF(EG67<=0.85,\"☆☆☆☆\",IF(EG67<=0.9,\"☆☆☆\",IF(EG67<=1,\"☆☆\",IF(EG67<=1.1,\"☆\",\"-\"))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを除いた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(OR($G$6=\"なし\",$G$6=\"あり（計算除外）\"),0,IF($G$23=\"標準入力法\",AC508,IF($G$23=\"照明簡易計算\",G63,0)))","v":0},{"$f":"IF(ISERROR(ROUNDUP((H24+H26+H28+H30+H32+H37-(H52-H57))/1000,1)),\"\",ROUNDUP((H24+H26+H28+H30+H32+H37-(H52-H57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((AN24+AN26+AN28+AN30+AN32+AN37-(AN52-AN57))/1000,1)),\"\",ROUNDUP((AN24+AN26+AN28+AN30+AN32+AN37-(AN52-AN57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((BT24+BT26+BT28+BT30+BT32+BT37-(BT52-BT57))/1000,1)),\"\",ROUNDUP((BT24+BT26+BT28+BT30+BT32+BT37-(BT52-BT57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((CZ24+CZ26+CZ28+CZ30+CZ32+CZ37-(CZ52-CZ57))/1000,1)),\"\",ROUNDUP((CZ24+CZ26+CZ28+CZ30+CZ32+CZ37-(CZ52-CZ57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((EF24+EF26+EF28+EF30+EF32+EF37-(EF52-EF57))/1000,1)),\"\",ROUNDUP((EF24+EF26+EF28+EF30+EF32+EF37-(EF52-EF57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((FL24+FL26+FL28+FL30+FL32+FL37-(FL52-FL57))/1000,1)),\"\",ROUNDUP((FL24+FL26+FL28+FL30+FL32+FL37-(FL52-FL57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを除いた一次エネルギー消費削減量(GJ)",null,null,null,null,null,{"$f":"IF(ISERROR(H64-H69),\"\",H64-H69)","v":""},{"$f":"IF(ISERROR(I64-I69),\"\",I64-I69)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BT64-BT69),\"\",BT64-BT69)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EF64-EF69),\"\",EF64-EF69)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを除いた一次エネルギー消費量削減率(%) ",null,null,null,null,null,{"$f":"IF(ISERROR(H70/H64),\"\",ROUNDDOWN(H70/H64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BT70/BT64),\"\",ROUNDDOWN(BT70/BT64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EF70/EF64),\"\",ROUNDDOWN(EF70/EF64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを加えた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(OR($G$6=\"なし\",$G$6=\"あり（計算除外）\"),0,IF($G$23=\"標準入力法\",AC509,IF($G$23=\"照明簡易計算\",G63,0)))","v":0},{"$f":"IF(ISERROR(ROUNDUP((H24+H26+H28+H30+H32-H52-H54)/1000,1)),\"\",IF((H24+H26+H28+H30+H32-H52-H54)<0,ROUNDDOWN((H24+H26+H28+H30+H32-H52-H54)/1000,1),ROUNDUP((H24+H26+H28+H30+H32-H52-H54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((AN24+AN26+AN28+AN30+AN32-AN52-AN54)/1000,1)),\"\",IF((AN24+AN26+AN28+AN30+AN32-AN52-AN54)<0,ROUNDDOWN((AN24+AN26+AN28+AN30+AN32-AN52-AN54)/1000,1),ROUNDUP((AN24+AN26+AN28+AN30+AN32-AN52-AN54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((BT24+BT26+BT28+BT30+BT32-BT52-BT54)/1000,1)),\"\",IF((BT24+BT26+BT28+BT30+BT32-BT52-BT54)<0,ROUNDDOWN((BT24+BT26+BT28+BT30+BT32-BT52-BT54)/1000,1),ROUNDUP((BT24+BT26+BT28+BT30+BT32-BT52-BT54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((CZ24+CZ26+CZ28+CZ30+CZ32-CZ52-CZ54)/1000,1)),\"\",IF((CZ24+CZ26+CZ28+CZ30+CZ32-CZ52-CZ54)<0,ROUNDDOWN((CZ24+CZ26+CZ28+CZ30+CZ32-CZ52-CZ54)/1000,1),ROUNDUP((CZ24+CZ26+CZ28+CZ30+CZ32-CZ52-CZ54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((EF24+EF26+EF28+EF30+EF32-EF52-EF54)/1000,1)),\"\",IF((EF24+EF26+EF28+EF30+EF32-EF52-EF54)<0,ROUNDDOWN((EF24+EF26+EF28+EF30+EF32-EF52-EF54)/1000,1),ROUNDUP((EF24+EF26+EF28+EF30+EF32-EF52-EF54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((FL24+FL26+FL28+FL30+FL32-FL52-FL54)/1000,1)),\"\",IF((FL24+FL26+FL28+FL30+FL32-FL52-FL54)<0,ROUNDDOWN((FL24+FL26+FL28+FL30+FL32-FL52-FL54)/1000,1),ROUNDUP((FL24+FL26+FL28+FL30+FL32-FL52-FL54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを加えた一次エネルギー消費削減量(GJ)",null,null,null,null,null,{"$f":"IF(ISERROR(H64-H72),\"\",H64-H72)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BT64-BT72),\"\",BT64-BT72)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EF64-EF72),\"\",EF64-EF72)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを加えた一次エネルギー消費量削減率(%) ",null,null,null,null,null,{"$f":"IF(ISERROR(H73/H64),\"\",ROUNDDOWN(H73/H64*100,0))","v":""},{"$f":"IF(ISERROR(I73/I64),\"\",ROUNDDOWN(I73/I64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BU73/BU64),\"\",ROUNDDOWN(BU73/BU64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EG73/EG64),\"\",ROUNDDOWN(EG73/EG64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"住宅の「ＺＥＨマーク」、「ゼロエネ相当」に関する表示",null,null,null,null,null,{"$f":"IF(OR(AND(H13=$D$489,H21=\"適合\",H22=\"適合\",H71>=20,H74>=100),AND(H13=$D$490,H21=\"適合\",H22=\"適合\",H71>=20,H74>=75,H74<100),AND(H13=$D$491,H21=\"適合\",H22=\"適合\",H71>=20,H74>=50,H74<75),AND(H13=$D$492,H21=\"適合\",H22=\"適合\",H71>=20),AND(H13=$D$493,H21=\"適合\",H71>=20,H74>=100)),\"適合\",\"-\")","v":"-"},{"$f":"IF(OR(AND(I13=$D$489,I21=\"適合\",I22=\"適合\",I71>=20,I74>=100),AND(I13=$D$490,I21=\"適合\",I22=\"適合\",I71>=20,I74>=75,I74<100),AND(I13=$D$491,I21=\"適合\",I22=\"適合\",I71>=20,I74>=50,I74<75),AND(I13=$D$492,I21=\"適合\",I22=\"適合\",I71>=20),AND(I13=$D$493,I21=\"適合\",I71>=20,I74>=100)),\"適合\",\"-\")","v":"-"},{"$f":"IF(OR(AND(J13=$D$489,J21=\"適合\",J22=\"適合\",J71>=20,J74>=100),AND(J13=$D$490,J21=\"適合\",J22=\"適合\",J71>=20,J74>=75,J74<100),AND(J13=$D$491,J21=\"適合\",J22=\"適合\",J71>=20,J74>=50,J74<75),AND(J13=$D$492,J21=\"適合\",J22=\"適合\",J71>=20),AND(J13=$D$493,J21=\"適合\",J71>=20,J74>=100)),\"適合\",\"-\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(OR(AND(BV13=$D$489,BV21=\"適合\",BV22=\"適合\",BV71>=20,BV74>=100),AND(BV13=$D$490,BV21=\"適合\",BV22=\"適合\",BV71>=20,BV74>=75,BV74<100),AND(BV13=$D$491,BV21=\"適合\",BV22=\"適合\",BV71>=20,BV74>=50,BV74<75),AND(BV13=$D$492,BV21=\"適合\",BV22=\"適合\",BV71>=20),AND(BV13=$D$493,BV21=\"適合\",BV71>=20,BV74>=100)),\"適合\",\"-\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(OR(AND(EH13=$D$489,EH21=\"適合\",EH22=\"適合\",EH71>=20,EH74>=100),AND(EH13=$D$490,EH21=\"適合\",EH22=\"適合\",EH71>=20,EH74>=75,EH74<100),AND(EH13=$D$491,EH21=\"適合\",EH22=\"適合\",EH71>=20,EH74>=50,EH74<75),AND(EH13=$D$492,EH21=\"適合\",EH22=\"適合\",EH71>=20),AND(EH13=$D$493,EH21=\"適合\",EH71>=20,EH74>=100)),\"適合\",\"-\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
[]
[null,"貼付けセル⇒"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"外皮性能住棟評価",null,null,null,null,null,null,null,"共用部","面積","MJ／延べ","①×延べ","MJ⇒GJ"]
["全住戸適合","申請する","性能基準","『ZEH』","『ZEH-M』","記載なし","記載なし",null,"記載なし",1,"0.46・-",0.4,0.46,"-","適合\n(性能基準)","UA値","0.41・-",null,null,null,null,null,null,null,"延べ面積",{"$f":"IF(J4=\"\",\"\",J4)","v":""}]
["不適合あり","申請しない","仕様基準","Nearly ZEH","Nearly ZEH-M","記載する","別紙による",null,"別紙による",2,"0.46・-",0.4,0.46,"-","－\n(対象外)","ηAC値","0.41・-",null,null,null,null,null,null,"基準","空調",null,{"$f":"IF($G$23=\"標準入力法\",G38,\"\")","v":""},{"$f":"AA490*$Z$489","v":{"$error":"#VALUE!"}}]
[null,null,"大臣の方法","ZEH Ready","ZEH-M Ready",null,"四面と同じ",null,"第四面と同じ",3,"0.56・-",0.5,0.56000000000000005,"-","適合\n(仕様基準)","希望しない","0.44・-",null,null,null,null,null,null,"基準","換気",null,{"$f":"IF($G$23=\"標準入力法\",G42,\"\")","v":""},{"$error":"#VALUE!"}]
[null,null,null,"ZEH Oriented","ZEH-M Oriented",null,null,null,null,4,"0.75・-",0.6,0.75,"-",null,null,"0.69・-",null,null,null,null,null,null,"基準","照明",null,{"$f":"IF($G$23=\"標準入力法\",G44,\"\")","v":""},{"$error":"#VALUE!"}]
[null,null,null,"ゼロエネ相当","記載しない",null,null,null,null,5,"0.87・3.0",0.6,0.87,3,null,null,"0.75・1.5",null,null,null,null,null,null,"基準","給湯",null,{"$f":"IF($G$23=\"標準入力法\",G46,\"\")","v":""},{"$error":"#VALUE!"}]
[null,null,null,"記載しない",null,null,null,null,null,6,"0.87・2.8",0.6,0.87,2.8,null,null,"0.75・1.4",null,null,null,null,null,null,"基準","昇降機",null,{"$f":"IF($G$23=\"標準入力法\",G48,\"\")","v":""},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,7,"0.87・2.7",0.6,0.87,2.7,null,null,"0.75・1.3",null,null,null,null,null,null,"設計","空調",null,{"$f":"IF($G$23=\"標準入力法\",G24,\"\")","v":""},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,8,"-・6.7","-","-",6.7,null,null,"-・2.8",null,null,null,null,null,null,"設計","換気",null,{"$f":"IF($G$23=\"標準入力法\",G28,\"\")","v":""},{"$error":"#VALUE!"}]
["標準入力法",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計","照明",null,{"$f":"IF($G$23=\"標準入力法\",G30,\"\")","v":""},{"$error":"#VALUE!"}]
["照明簡易計算",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計","給湯",null,{"$f":"IF($G$23=\"標準入力法\",G32,\"\")","v":""},{"$error":"#VALUE!"}]
["共用部なし",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計","昇降機",null,{"$f":"IF($G$23=\"標準入力法\",G34,\"\")","v":""},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"基準・設計","その他",null,{"$f":"IF($G$23=\"標準入力法\",G49,\"\")","v":""},{"$f":"AA500*Z489","v":{"$error":"#VALUE!"}},{"$f":"ROUND(AB500/1000,2)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計","太陽光　自己消費量　MJ",null,null,{"$f":"G35","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計","発電量（太陽光発電）　GJ",null,null,null,{"$f":"IFERROR(G54,0)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"基準合計","その他除く",null,null,{"$f":"SUM(AB490:AB494)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB503/1000,1)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"基準合計","その他含む",null,null,{"$f":"SUM(AB490:AB494,AB500)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB504/1000,1)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計合計","その他除く　自己消費量を考慮",null,null,{"$f":"SUM(AB495:AB499,AB501)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB505/1000,1)","v":{"$error":"#VALUE!"}},null,"設計一次エネルギー消費量（太陽光除く）の合計（GJ）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計合計","その他含む　自己消費量を考慮","太陽光除く",null,{"$f":"SUM(AB495:AB500)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB506/1000,1)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR(G61=\"\",G23=\"照明簡易計算\",M512=\"無し\"),\"\",ROUND(G61+AC500+M518,1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計合計","その他含む　自己消費量を考慮",null,null,{"$f":"SUM(AB495:AB501)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB507/1000,1)","v":{"$error":"#VALUE!"}},null,"合計その他抜きGJから、その他を追加し、太陽光足し戻し"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計合計","その他・再エネ除き",null,null,{"$f":"SUM(AB495:AB499)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUNDUP(AB508/1000,1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設計合計","その他除く、再エネ（売電含む）含む",null,null,{"$f":"SUM(AB495:AB499)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUNDUP(AB509/1000,1)+AC502,0)","v":0}]
[]
[null,"【住棟のZEH-M等に関わる判定】",null,null,null,null,null,null,"【共同住宅等の共用部の太陽光発電設備に関する事項】",null,null,null,null,null,null,null,null,null,"※参考：照明簡易計算の一次エネ換算値"]
[null,"選択した表示",null,null,null,{"$f":"IF(E13=\"\",\"\",E13)","v":"『ZEH-M』"},null,null,"共用部の太陽光発電設備の設置の有無",null,null,null,null,null,null,null,null,null,"照明設備","設計",{"$f":"IF(AND(G23=\"照明簡易計算\",G6=\"あり（計算する）\"),ROUNDUP(G61/J4,2),\"\")","v":""},"MJ/延床㎡年"]
[null,"全住戸の外皮の省エネ基準への適合状況",null,null,null,null,null,null,"太陽光発電設備の共有",null,null,null,null,null,null,null,null,null,null,"基準",{"$f":"IF(AND(G23=\"照明簡易計算\",G6=\"あり（計算する）\"),ROUNDUP(G64/J4,2),\"\")","v":""},"MJ/延床㎡年"]
[null,"全住戸の強化外皮基準への適合状況",null,null,null,null,null,null,"主たる廊下の形状",null,null,null,null,null,null,null,null,null,"合計","設計",{"$f":"IF(AND(G23=\"照明簡易計算\",G6=\"あり（計算する）\"),G62,\"\")","v":""},"GJ/年"]
[null,"再生可能エネルギーを除いた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(E67=\"\",\"\",IF((ISERROR(ROUNDUP((F24+F26+F28+F30+F32+F37-(F52-F57))/1000+G69,1))),\"\"\"\",ROUNDUP((F24+F26+F28+F30+F32+F37-(F52-F57))/1000+G69,1)))","v":""},null,"設計一次エネルギー消費量（太陽光除く）の合計（GJ）",null,null,null,{"$f":"IF(OR(G61=\"\",G23=\"照明簡易計算\",M512=\"無し\"),\"\",AC506)","v":""},null,"←自動計算",null,null,null,"その他 除・含","基準",{"$f":"IF(AND(G6=\"あり（計算する）\",G23=\"照明簡易計算\"),G65,\"\")","v":""},"GJ/年"]
[null,"再生可能エネルギーを除いた基準一次エネルギー消費削減量(GJ)",null,null,null,null,{"$f":"IF(ISERROR(E66-G515),\"\",E66-G515)","v":""},null,"共用部の太陽光発電による削減量（自己消費量）(MJ)",null,null,null,{"$f":"IF(OR(M513=\"\",M515=\"\",M514=\"\"),\"\",IF(OR(M514=\"屋外\",M514=\"―\"),0,IF(M514=\"屋内\",IF(M513=\"住戸・共用部で共有\",IF(F59/1000>=M515*0.3,M515*1000*0.3,F59),IF(M518=\"\",\"\",IF(M518>=M515*0.3,M515*1000*0.3,M518*1000))))))","v":""},null,"←主たる廊下の形状「屋内」「屋外」による自己消費量（自動計算）"]
[null,"再生可能エネルギーを除いた一次エネルギー消費量削減率(%) ",null,null,null,null,{"$f":"IF(ISERROR(G516/E66),\"\",ROUNDDOWN(G516/E66*100,0))","v":""},null,null,null,null,null,null,null,"←主たる廊下の形状「―」による自己消費量（手入力）"]
[null,"再生可能エネルギーを加えた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(E67=\"\",\"\",IF(ISERROR(ROUNDUP((F24+F26+F28+F30+F32-F52-F54)/1000+G72,1)),\"\",IF((F24+F26+F28+F30+F32-F52-F54)<0,ROUNDDOWN((F24+F26+F28+F30+F32-F52-F54)/1000+G72,1),ROUNDUP((F24+F26+F28+F30+F32-F52-F54)/1000+G72,1))))","v":""},null,"共用部の太陽光発電量（総発電量）(GJ)",null,null,null,null,null,"←マイナス無し入力"]
[null,"再生可能エネルギーを加えた基準一次エネルギー消費削減量(GJ)",null,null,null,null,{"$f":"IF(ISERROR(E66-G518),\"\",E66-G518)","v":""},null,"※共用部の計算方法が標準入力法の場合のみ、入力が必要です。"]
[null,"再生可能エネルギーを加えた一次エネルギー消費量削減率(%) ",null,null,null,null,{"$f":"IF(ISERROR(G519/E66),\"\",ROUNDDOWN(G519/E66*100,0))","v":""},null,"※黒塗りのセルへの入力は不要です。"]
[null,"住棟の「ＺＥＨ―Ｍマーク」に関する表示",null,null,null,null,{"$f":"IF(E67=\"\",\"\",IF(OR(AND(E13=$E$489,G513=\"全住戸適合\",G514=\"全住戸適合\",G517>=20,G520>=100),AND(E13=$E$490,G513=\"全住戸適合\",G514=\"全住戸適合\",G517>=20,G520>=75,G520<100),AND(E13=$E$491,G513=\"全住戸適合\",G514=\"全住戸適合\",G517>=20,G520>=50,G520<75),AND(E13=$E$492,G513=\"全住戸適合\",G514=\"全住戸適合\",G517>=20)),\"適合\",\"-\"))","v":""},null,"※太陽光発電設備を非住宅用途と共有する場合、本計算書は使用できません。別途ご相談下さい。"]

{"sheet":"共用部入力方法（標準入力法）","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"共用部入力方法 (照明簡易計算)","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"太陽光発電設備の住戸按分計算シート","index":3,"n_rows":49,"n_cols":50,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,37],[3,1,8,35],[35,21,35,32],[36,21,36,32],[37,21,37,32],[28,21,28,32],[29,21,29,32],[38,21,38,32],[39,21,39,32],[22,4,22,10],[22,11,22,17],[22,18,22,20],[22,21,22,32],[23,4,23,10],[23,11,23,17],[23,18,23,20],[23,21,23,32],[19,11,19,17],[19,18,19,20],[19,21,19,32],[20,4,20,10],[20,11,20,17],[20,18,20,20],[20,21,20,32],[45,41,45,47],[33,41,33,47],[34,41,34,47],[40,41,40,47],[41,41,41,47],[42,41,42,47],[37,41,37,47],[38,41,38,47],[28,41,28,47],[29,41,29,47],[30,41,30,47],[31,41,31,47],[32,41,32,47],[39,41,39,47],[47,11,47,17],[47,18,47,20],[47,4,48,10],[48,11,48,17],[48,18,48,20],[47,21,48,32],[14,41,16,47],[17,41,17,47],[18,41,18,47],[19,41,19,47],[20,41,20,47],[21,41,21,47],[22,41,22,47],[23,41,23,47],[43,41,43,47],[44,41,44,47],[24,41,24,47],[25,41,25,47],[26,41,26,47],[27,41,27,47],[35,41,35,47],[36,41,36,47],[46,41,46,47],[47,41,47,47],[44,4,44,10],[44,11,44,17],[44,18,44,20],[44,21,44,32],[45,4,45,10],[45,11,45,17],[45,18,45,20],[45,21,45,32],[46,4,46,10],[46,11,46,17],[46,18,46,20],[46,21,46,32],[43,4,43,10],[43,11,43,17],[43,18,43,20],[43,21,43,32],[30,21,30,32],[31,21,31,32],[40,21,40,32],[41,21,41,32],[32,21,32,32],[33,21,33,32],[42,21,42,32],[21,4,21,10],[21,11,21,17],[21,18,21,20],[21,21,21,32],[34,21,34,32],[24,21,24,32],[25,21,25,32],[26,21,26,32],[27,21,27,32],[10,1,10,7],[10,8,10,37],[12,1,12,14],[12,15,12,22],[14,4,16,10],[14,11,16,17],[14,21,16,32],[12,24,12,29],[12,30,12,37],[14,18,16,20],[17,4,17,10],[17,11,17,17],[17,18,17,20],[17,21,17,32],[18,4,18,10],[18,11,18,17],[18,18,18,20],[18,21,18,32],[19,4,19,10]]}
[]
[null,"太陽光発電設備の住戸按分計算シート"]
[]
[null,"本シートは、1又は複数の太陽光発電設備が複数の住戸に接続されており、発電設備と各住戸の消費の関係が明らかでない場合に各住戸に対応する太陽電池アレイのシステム容量を面積按分する際に利用してください。このシートで算定される「計算用仮想システム容量」をWebプログラムの各住戸の計算へ適用することになります。なお、異なる方位に太陽光発電設備が設置される場合は、本シートをコピーしてご利用ください。（最大４面）"]
[]
[]
[]
[]
[]
[]
[null,"建築物の名称"]
[]
[null,"太陽電池アレイのシステム容量（kW）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"パネルの方位"]
[]
[null,null,null,null,"室名称\n（タイプ名称）",null,null,null,null,null,null,"単位住戸床面積\n（㎡）",null,null,null,null,null,null,"戸数",null,null,"計算用仮想システム容量\n（kW/戸）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"単位住戸床面積\n×戸数"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"真南から東および西へ15度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"真南から東へ15度以上45度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND($P$13*AP18/$AP$48/S18,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L18*S18","v":0},null,null,null,null,null,null,null,"真南から東へ45度以上75度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND($P$13*AP19/$AP$48/S19,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"真南から東へ75度以上105度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"真南から東へ105度以上135度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"真南から東へ135度以上165度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"真南から東および西へ165度以上真北まで"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"真南から西へ135度以上165度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"真南から西へ105度以上135度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L25*S25","v":0},null,null,null,null,null,null,null,"真南から西へ75度以上105度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"真南から西へ45度以上75度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"真南から西へ15度以上45度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L44*S44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L45*S45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L46*S46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND($P$13*AP47/$AP$48/S47,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L47*S47","v":0}]
[null,null,null,null,"合計",null,null,null,null,null,null,{"$f":"SUM(L18:R47)","v":0},null,null,null,null,null,null,{"$f":"SUM(S18:U47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP18:AV47)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"㎡",null,null,null,null,null,null,"戸",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"㎡"]

{"sheet":"【参考】共用部の太陽光発電の扱いについて","index":4,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["　※廊下形状「屋内」「屋外」を選択した場合、共用部の自己消費量は上記に従い下記の通り計算が行われます。"]
[]
["①主たる廊下の形状が「屋外」"]
["　　⇒上記表1により係数が0となるため、自己消費量は0"]
[]
["②主たる廊下の形状が「屋内」",null,null,null,null,null,null,null,null,null,"別途、国立研究開発法人建築研究所の技術情報、4.参考情報に掲載されている計算方法により、"]
["　上記表1により係数は0.3となる。",null,null,null,null,null,null,null,null,null,"太陽光発電による一次エネルギー消費量の削減分を計算することも認められます。"]
[null,null,null,null,null,null,null,null,null,null,"平成28年省エネルギー基準に準拠したエネルギー消費性能の評価に関する技術情報（非住宅建築物）"]
["　②-1太陽光発電設備の共有が「住戸・共用部で共有」の場合",null,null,null,null,null,null,null,null,null,"共同住宅共用部における太陽光発電設備の評価方法"]
["　"]
["　　住戸の売電量の合計≧共用部の設計一次エネ（太陽光除き）×0.3"]
["　　⇒設計一次エネ（太陽光除き）×0.3が共用部の自己消費量"]
[]
["　　住戸の売電量の合計＜共用部の設計一次エネ（太陽光除き）×0.3"]
["　　⇒住戸の売電量の合計が共用部の自己消費量"]
[]
["　②-2太陽光発電設備の共有が「共有無し」の場合"]
[]
["　　共用部の太陽光発電量≧共用部の設計一次エネ（太陽光除き）×0.3"]
["　　⇒設計一次エネ（太陽光除き）×0.3が共用部の自己消費量"]
[]
["　　共用部の太陽光発電量＜共用部の設計一次エネ（太陽光除き）×0.3"]
["　　⇒共用部の太陽光発電量が共用部の自己消費量"]

{"sheet":"Ver情報","index":5,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
["2018-08-08","Ver1.1.0","①ηACが整数となる場合にηACが自動入力されない不具合の解消"]
[null,null,"②住戸のZEH Orientedの太陽光含みの削減率の必要条件を20％以上、50％未満に修正"]
[null,null,"③Verj情報が印刷されない不具合を修正"]
["2018-08-23","Ver1.1.1","①Ｈ列の住戸名称を入力してもデフォルト住戸数「1」が表示されない不具合を解消"]
[null,null,"（Ver1.1.0の使用でも問題はありません。）"]
["2018-09-13","Ver1.2.0","①太陽光発電設備の住戸按分計算シートを新規掲載しました。按分する際にご利用ください。"]
[null,null,"②共用部の計算手法を「照明簡易計算」とした場合、照明設備にマスクがかかる不具合を修正。"]
[null,null,"③【共同住宅等の共用部の太陽光発電設備に関する事項】において、主たる廊下の形状を「屋外」とした場合、共用部の太陽光発電量（総発電量）にマスクがかかる不具合を修正。"]
[null,null,"④「【参考】共用部の太陽光の扱いについて」のシートに共用部の自己消費量の考え方を追記しました。"]
[null,null,"⑤本シートの作成手順に記載の「対応する計算のVer」を2.4.2から2.4.3に修正しました。"]
[null,null,"⑥計算結果貼付けについて、Adobe以外のアプリケーションで展開した場合に適切な計算結果が読み込めないことを記載。"]
["2018/10","Ver2.0.0","WebプログラムVer2.5.0以降の計算書に対応"]
["2018-11-16","Ver2.0.1","計算書において、Ｒ列が表示されていない不具合を修正"]
["2018-11-19","Ver2.0.2","Ｒ列に計算式が反映されていない不具合を修正"]
["2018-11-29","Ｖｅｒ2.1.0"," Ver2.0.2で確認された内容に加え、Ｒ列に計算式が反映されていない不具合を修正"]
["2019-04-22","Ｖｅｒ3.0.0","WebプログラムVer2.6.0以降の計算書に対応"]
["2019/5","Ｖｅｒ3.1.0","太陽光発電設備、コージェネレーション設備ともに設置がない場合、数値が適切に表示されない不具合を解消しました。"]
["2019/7","Ｖｅｒ3.1.1","計算対象面積が正しく反映されない不具合を解消しました。"]
["2019/11","Ver3.2.0","共用部を除外する計算方法と外皮性能の住棟評価に対応しました。"]
["2019/11","Ver3.2.1","共用部がない（長屋等）の場合にZEH-Mの判定ができない不具合を解消しました。"]
["2019/12","Ver3.3.0","PDFを読み込んだ際に地域区分が反映しない不具合を解消しました。"]
["2020/3","Ver3.3.1","2020年4月の基準省令の改正に基づき、8地域の冷房期平均日射熱取得率の基準値を変更しました。"]
["2020/4","Ver3.4.0","共用部の太陽光発電の扱いについて修正を行いました。"]
["2020/12","Ver3.4.1","住戸：ZEH Oriented、住棟：ZEH-M Orientedを表示希望する場合、再エネ含みの削減率が50％以上の場合に「適合」が表示されない不具合を修正しました。"]
["2021/4","Ver.3.4.2","売電量（太陽光発電）の計算方法の修正　※計算結果に影響はありません"]
["2021/4","Ver.4.0.0","WebプログラムVer.3.0の計算書に対応"]
["2022/5","Ver.4.1.0","（一社）BELS評価書作成プログラムバージョンアップに伴うBEI及びZEH-Mの削減率の各算定方法の修正"]
[null,null,"上記に伴い共用部において、「設計一次エネルギー消費量の合計値」、「基準一次エネルギー消費量の合計値」を入力するよう変更しました。"]
[null,null,"上記に伴い共用部において、簡易照明計算を選択した場合の入力方法を変更しました。"]
[null,null,"必要項目の入力や選択が無い場合に、BEI及び削減率の計算結果が表示されないよう修正しました。"]
[null,null,"タブ「入力の注意点」を追加"]
["2022/8/15","Ver.4.1.1","共用部に太陽光発電設備の設置がある場合に、BEI算定時の不具合を修正"]
[null,null,"住戸：ZEH Oriented　再エネ含みの削減率が50％以上の場合に「適合」が表示されない不具合を修正"]
[null,null,"設計及び基準一次エネルギー消費量の表示・入力欄の順番の入替"]
[null,null,"共用部の入力内容に係わるクリアボタンを設置"]
[null,null,"照明簡易計算を用いた場合の換算値を表示"]
["2022/8/31","Ver.4.1.2","住戸：ZEH Oriented、を表示希望する場合、再エネ含みの削減率が20％未満の場合に「適合」が表示される不具合を修正しました。"]